﻿--Account-----------------
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Account]'))
DROP TABLE [Account]
GO
CREATE TABLE [Account](
	[Key] [uniqueidentifier] NOT NULL DEFAULT NEWID(),
	[DomainScopeKey] [uniqueidentifier] NOT NULL,
	[LoginIdentity] [nvarchar](MAX) NOT NULL,
	[LoginPassword] [nvarchar](MAX) NOT NULL,
	[Email] [nvarchar](200) NOT NULL,
	[PersonKey] [uniqueidentifier] NULL,
	[CreatedStamp] [datetime] NOT NULL,
	[LastUpdatedStamp] [datetime] NOT NULL,
 CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED ([Key] ASC)) ON [PRIMARY]
GO
